SalesForce

You can use SalesForce Object Query Language (SOQL) queries to drive data extraction from your SalesForce data source, enabling you to filter and join the data before pulling it into Pyramid. This gives you control over what data is imported into the ETL.

SalesForce Filtering with SOQL

In order to filter your SalesForce data, you need to connect the SQL Query node to the SalesForce node:

With the SQL Query node selected, enter to SOQL script into the script window. The script for each node will return the data as a table. To configure multiple tables, you must connect multiple SQL Query nodes to the SalesForce node, and add an SOQL script to each node.

In the image below, the script will produce a table containing the names and emails of customers in Sydney:

SELECT Name, Email FROM Customers WHERE City = 'Sydney'

Custom Domain

If you are querying a custom SalesForce domain, the admin must ensure that this option is enabled and the custom domain provided in the Admin console.